package com.yunxi.dao.otd;

import com.yunxi.core.dao.BaseMapperPlus;
import com.yunxi.model.otd.ProducePlanView;
import com.yunxi.otd.pojo.VehicleOtdInfoVO;
import com.yunxi.otd.pojo.VehicleOtdVO;
import java.util.Date;
import org.apache.ibatis.annotations.Param;

/**
 * <p>
 * VIEW Mapper 接口
 * </p>
 *
 * @author  XUQI
 * @since 2019-08-17
 */
public interface ProducePlanViewMapper extends BaseMapperPlus<ProducePlanView> {

    /**
     * 查询OTD标尺
     * @param startNodeCode 开始节点
     * @param startDate 节点开始时间
     * @return OTD
     */
    VehicleOtdVO selectOtdRuler(@Param("startNodeCode") String startNodeCode, @Param("startDate") Date startDate);


    /**
     * 查询OTD计划
     * @param planNO 计划编号
     * @return VehicleOtdVO
     */
    VehicleOtdVO selectOtdPlanDate(@Param("planNo") String planNO);


    /**
     * 查询OTD实际
     * @param planNO 计划编号
     * @return VehicleOtdVO
     */
    VehicleOtdVO selectOtdActualDate(@Param("planNo") String planNO);

    /**
     * 生产计划编号查询OTD信息
     * @param planNO 计划编号
     * @return  VehicleOtdInfoVO
     */
    VehicleOtdInfoVO selectOtdInfoByPlanNo(@Param("planNo") String planNO);





}
